www.gusucode.com > RQCMS PHP文章管理系统 v2.3PHP源码程序 > RQCMS PHP文章管理系统 v2.3/rqcms_v2.3/rqcms_v2.3/core/manager/link.php

    <?php
if(RQ_POST)
{
	if($action == 'addlink') 
	{
		$name    = trim($_POST['name']);
		$url     = trim($_POST['url']);
		$note    = trim($_POST['note']);
		$bak    = trim($_POST['bak']);
		$visible = intval($_POST['visible']);
		$result  = checksitename($name);
		$result .= checkurl($url,0);
		$result .= checknote($note);
		if($result) 
		{
			redirect($result);
		}
		$name    = char_cv($name);
		$url     = char_cv($url);
		$note    = char_cv($note);
		$rs = $DB->fetch_first("SELECT count(*) AS links FROM ".DB_PREFIX."link WHERE name='$name' AND url='$url'  ");
		if($rs['links'])
		{
			redirect('该链接在数据库中已存在', $admin_url.'?file=link');
		}
		$DB->query("INSERT INTO ".DB_PREFIX."link (name, url, note, visible,bak) VALUES ('$name', '$url', '$note' ,'$visible','$bak')");
		setting_recache();
		redirect('添加链接成功', $admin_url.'?file=link');
	}
	else if($action=='domorelink')
	{
		if(isset($_POST['delete'])&&$ids = implode_ids($_POST['delete']))
		{
			$DB->query("DELETE FROM	".DB_PREFIX."link WHERE lid IN ($ids)  ");
		}
		if(is_array($_POST['name'])) 
		{
			foreach($_POST['name'] as $linkid => $value) 
			{
				$DB->unbuffered_query("UPDATE ".DB_PREFIX."link SET displayorder='".intval($_POST['displayorder'][$linkid])."', name='".char_cv(trim($_POST['name'][$linkid]))."', url='".char_cv(trim($_POST['url'][$linkid]))."', note='".char_cv(trim($_POST['note'][$linkid]))."', visible='".intval($_POST['visible'][$linkid])."',bak='".$_POST['bak'][$linkid]."' WHERE lid='".intval($linkid)."'  ");
			}
		}
		setting_recache();
		redirect('链接已成功更新', $admin_url.'?file=link');
	}
}

if(!$action) $action = 'list';


// 检查链接名字是否符合逻辑
function checksitename($sitename) {
	if(!$sitename || strlen($sitename) > 30) {
		$result = '站点名不能空并不能大于30个字符<br />';
		return $result;
	}
	elseif(preg_match("[<>{}(),%#|^&!`$]",$sitename)) {
		$result = '站点名中不能含有特殊字符<br />';
		return $result;
	}
}

// 检查链接描述是否符合逻辑
function checknote($note = '') 
{
	if($note && strlen($note) > 200) 
	{
		$result = '站点描述不能大于200个字符<br />';
		return $result;
	}
	
}
if($action == 'add') $subnav = '添加链接';
if ($action == 'list')
 {
	$query = $DB->query("SELECT * FROM ".DB_PREFIX."link ORDER BY displayorder");
	$linkdb = array();
	while ($link = $DB->fetch_array($query))
	{
		if ($link['visible'] == '1') {
			$link['visible'] = '<option value="1" selected>显示</option><option value="0">隐藏</option>';
		} else {
			$link['visible'] = '<option value="1">显示</option><option value="0" selected>隐藏</option>';
		}
		$linkdb[] = $link;
	}
	unset($link);
	$DB->free_result($query);
	$subnav = '编辑链接';
}